/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package roomarrange;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.sql.rowset.CachedRowSetXImpl;
import com.sun.webui.jsf.component.PasswordField;
import com.sun.webui.jsf.component.TextField;
import java.sql.SQLException;
import javax.faces.FacesException;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;
/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version Page2.java
 * @version Created on 2009-10-27, 14:46:33
 * @author ben
 */

public class Page2 extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
    }
    private TextField textField1 = new TextField();

    public TextField getTextField1() {
        return textField1;
    }

    public void setTextField1(TextField tf) {
        this.textField1 = tf;
    }
    private PasswordField passwordField1 = new PasswordField();

    public PasswordField getPasswordField1() {
        return passwordField1;
    }

    public void setPasswordField1(PasswordField pf) {
        this.passwordField1 = pf;
    }

    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public Page2() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("Page2 Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    public String button1_action() throws SQLException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        String ls_usr,ls_pwd,ls_pwd2,ls_crname,ls_conn;
        int li_usrid;
        ls_usr="";
        ls_pwd="";
        if(this.getTextField1().getValue()==null){
            info("用户名不能为空");
            return null;
        }
        if(this.getPasswordField1().getValue()==null){
            info("密码不能为空");
            return null;
        }
        ls_usr = (String)this.getTextField1().getValue();
        ls_pwd=(String)this.getPasswordField1().getValue();
        if((ls_usr.length()==0)||(ls_usr==null)){
            info("用户名不能为空");
            return null;
        }
        if((ls_pwd.length()==0)||(ls_pwd==null)){
            info("密码不能为空");
            return null;
        }
        //从数据库中取值验证
        CachedRowSetXImpl usrRs;
        ls_conn = this.getApplicationBean1().getGs_conn();
        usrRs = new CachedRowSetXImpl();
        usrRs.setDataSourceName(ls_conn);
        usrRs.setCommand("select cpwd,crealname,i_id from t_usrset where cname = ?");
        usrRs.setTableName("t_usrset");
        usrRs.setString(1, ls_usr);
        usrRs.execute();
        if (usrRs.size()>0){
            usrRs.first();
            ls_pwd2 = usrRs.getString(1);
            ls_crname = usrRs.getString(2);
            li_usrid = usrRs.getInt(3);
            if (ls_pwd.equals(ls_pwd2)){

                String app = "workspace";
                HttpSession hs;
                hs = (HttpSession)FacesContext.getCurrentInstance().getExternalContext().getSession(false);
                if(hs!=null){
                    hs.setAttribute("usr_id", li_usrid);
                    hs.setAttribute("app", app);
                }
                this.getSessionBean1().setIusrid(li_usrid);
                this.getSessionBean1().setSpwd(ls_pwd);
                this.getSessionBean1().setSRealName(ls_crname);
                //将其他的变量清空
                this.getSessionBean1().setIMtHost(0);
                this.getSessionBean1().setIMtInitdept(0);
                this.getSessionBean1().setIroomid(0);
                this.getSessionBean1().setSEdate("");
                this.getSessionBean1().setSSdate("");
                this.getSessionBean1().setSUUID("");
                this.getSessionBean1().setSMtAbstract("");
                this.getSessionBean1().setSMtName("");
                this.getSessionBean1().setSMtNotice("");
                this.getSessionBean1().setSApp(app);
                if(ls_usr.equals("admin")){
                    return "toAdmin";
                }else{
                    return "toWorkSpace";
                }

            }else{
                info("错误的用户名和密码，请重试！");
            }
        }else{
            info("错误的用户名和密码，请重试！");
        }
        usrRs.close();
        return null;
    }
    
}

